Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_16

R_16

Category

LCategoryEvent

CategoryID

 

 

R_17

R_17

Event

LCategoryEvent

EventID

 

 

R_18

R_18

CategoryDictionary

LCategoryEvent

CategoryDictionaryID

 

 

R_169

R_169

BedsType

Event

BedsTypeID

 

 

R_184

R_184

DiagnosisType

LEventICD

DiagnosisTypeID

 

 

R_187

R_187

DiagnosisType

DiagnosisTypeText

DiagnosisTypeID

 

 

R_188

R_188

Language

DiagnosisTypeText

LanguageID

 

 

R_189

R_189

DiagnosisKind

LEventICD

DiagnosisKindID

 

 

R_190

R_190

DiagnosisKind

DiagnosisKindText

DiagnosisKindID

 

 

R_191

R_191

Language

DiagnosisKindText

LanguageID

 

 

R_216

R_216

ICDRevision

ICD

ICDRevisionID

 

 

R_217

R_217

ICDRevision

ICDRevisionText

ICDRevisionID

 

 

R_218

R_218

Language

ICDRevisionText

LanguageID

 

 

R_261

R_261

Episode

DiagnosticEvent

EpisodeID

 

 

R_263

R_263

DiagnosticEvent

LDiagnosticEventEvent

DiagnosticEventID

 

 

R_264

R_264

Event

LDiagnosticEventEvent

EventID

 

 

R_265

R_265

Event

DiagnosticEvent

EventID

 

 

R_266

R_266

Event

DiagnosticEvent

Eve_EventID

 

 

R_343

R_343

Patient

Episode

PersonID

 

 

R_417

R_417

Event

LSuspensionEvent

EventID

 

 

R_418

R_418

Suspension

LSuspensionEvent

SuspensionID

 

 

R_506

R_506

PersonnelFunction

PersonnelFunctionText

PersonnelFunctionID

 

 

R_507

R_507

Language

PersonnelFunctionText

LanguageID

 

 

R_633

R_633

Event

LEventICD

EventID

 

 

R_634

R_634

ICD

LEventICD

ICDID

 

 

R_635

R_635

ICD

ICDText

ICDID

 

 

R_637

R_637

Language

ICDText

LanguageID

 

 

R_650

R_650

Category

CategoryText

CategoryID

 

 

R_651

R_651

Category

CategoryDictionary

CategoryID

 

 

R_653

R_653

CategoryDictionary

CategoryDictionaryText

CategoryDictionaryID

 

 

R_701

R_701

EventStatus

Event

EventStatusID

 

 

R_702

R_702

EventStatus

EventStatusText

EventStatusID

 

 

R_703

R_703

Language

EventStatusText

LanguageID

 

 

R_811

R_811

Personnel

Personnel

Per_PersonID3

 

 

R_812

R_812

Episode

SickLeave

EpisodeID

 

 

R_813

R_813

Patient

Patient

Pat_PersonID

 

 

R_814

R_814

Event

SickLeave

EventID

 

 

R_1316

R_1316

ICD

LOrgUnitICD

ICDID

 

 

R_1534

R_1534

Event

LEventEvent

EventID

 

 

R_1535

R_1535

Event

LEventEvent

Eve_EventID

 

 

R_1712

R_1712

ICD

LICDDRGRank

ICDID

 

 

R_1830

R_1830

ICDRevision

ICDVersion

ICDRevisionID

 

 

R_1831

R_1831

ICDVersion

ICDVersionText

ICDVersionID

 

 

R_1832

R_1832

ICDVersion

ICD

ICDVersionID

 

 

R_7050

R_7050

Event

DiagnosesHistory

EventID

 

 

R_7051

R_7051

Episode

DiagnosesHistory

EpisodeID

 

 

R_7052

R_7052

Person

DiagnosesHistory

PersonID

 

 

R_7053

R_7053

ICD

DiagnosesHistory

ICDID

 

 

R_7054

R_7054

DiagnosisType

DiagnosesHistory

DiagnosisTypeID

 

 

R_7055

R_7055

DiagnosisKind

DiagnosesHistory

DiagnosisKindID

 

 


2